# -*- coding: utf-8 -*-
"""
Created on Tue Aug 25 17:54:37 2020

@author: Lenovo
"""


# -*- coding: utf-8 -*-
"""
Created on Sat Aug 15 15:16:35 2020

@author: Lenovo
"""

import datetime,os
import pandas as pd
pwd = os.getcwd() #获取当前文件夹路径
father_path=os.path.abspath(os.path.dirname(pwd)+os.path.sep+".") #获取父文件夹路径
# df=pd.read_excel(father_path+"\8月现货数据.xlsx",sheet_name=0)
df=pd.read_excel(father_path+"\8月现货数据.xlsx",sheet_name=0,header=[0,1])
print(df.median())
